home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Night Owl 6
/
Night Owl's Shareware - PDSI-006 - Night Owl Corp (1990).iso
/
026a
/
mym2db11.zip
/
MYM2DB.DOC
next >
Wrap
Text File
|
1991-06-30
|
11KB
|
473 lines
MYM2DB (TM)
A Utility to convert Managing Your Money (tm)
BUDGET.ARK files to Dbase III format.
Copyright (C) 1991 Indusoft Corp.
Indusoft Corp.
PO. Box 26747
Greenville, SC 29616-1747
MYM2DBd, (C) Copyright 1991 Indusoft Corp. page -1-
OVERVIEW
MYM2DB only does 1 thing - it reads the BUDGET.ARK file from
your transactions archived with MYM, and converts them into
a delimited file which can easily be imported into Dbase III.
I wrote MYM2DB because I didn't particularly care for MYM's
graphing and filtering capabilities. I knew Dbase so....
The BUDGET.ARK tranactions created by MYM version 6.0 (no other
versions have been tested), are stored in variable length
records. Any transaction may allocate money to 1 OR MORE budget
accounts. MYM2DB understands this fact and will correctly
build 1 database record for each allocation. This way you can
sort and report by budget category, as well as by who got/gave
you your money.
SYNTAX:
MYM2DB is invoked this way:
Mym2db [input_filename] [output_filename]
(defaults) BUDGET.ARK BUDGET.TXT
Options are:
/? - get help info.
/D - write an empty Database (BUDGET.DBF) compatible with
Budget.TXT for you to append to.
Note that MYM2db does not require any arguments. If you do not
specify input and output filenames, MYM2DB will default to the
values shown.
MYM2DB will look for BUDGET.ARK (or the input filename you
specify) first in the current directory. If not found, it will
look in the \MYM subdirectory for filename. The output file
will always be written to the current directory.
Getting your info into a Dbase style database is a simple
process.
(1) Run MYM2db.
(2) Get into DBase or your favorite clone and type.
"USE BUDGET"
"APPEND FROM BUDGET.TXT DELIMITED"
MYM2DBd, (C) Copyright 1991 Indusoft Corp. page -2-
DATABASE STRUCTURE
The shareware version of MYM2DB does not directly build the
Dbase compatible file (there has to be something you get for
registering). However, it will build an empty database
structure called BUDGET.DBF ready for you to append the
delimited file into. Below is the structure of BUDGET.DBF.
Structure for database: BUDGET.DBF
Number of data records: 0
Date of last update : xx/xx/91
Field Field Name Type Width Dec
1 CDATE Character 8
2 WHO Character 50
3 ADDR1 Character 25
4 ADDR2 Character 25
5 ADDR3 Character 25
6 RECEIVED Numeric 8 2
7 SPENT Numeric 8 2
8 METHOD Character 5
9 F4 Character 10 - what is this folks???
10 COMMENT Character 50
11 ACCT_NAME Character 25
12 ACCT_NUM Character 10
13 ACCT_AMT Numeric 8 2
14 CATEGORY Character 20
15 EXP_INCOME Character 10
16 TAXCATEGOR Character 25
17 DDATE Date 8 - unused in shareware version.
** Total ** 321
Look at the fields of a "spend money" screen and you will see
that this structure mirrors the field contents from roughly top
to bottom, left to right.
MYM2DBd, (C) Copyright 1991 Indusoft Corp. page -3-
CONTENTS
This self extracting file should contain the following files:
mym2db.exe - the program itself.
mym2db.doc - these docs.
read.me - any last minute info.
SUPPORT
Indusoft Corp. can be contacted as follows:
Phone: (803)-292-9066
Please leave name, phone (including area code),
and times when you can be reached.
I WILL CALL COLLECT.
Compuserve ID: 73517,1107
I check for mail every couple of days.
This is the preferred method.
Ilink BBS Network (Shareware Connferance)
I check for mail every couple of days.
Leave message for ALAN DEAN.
TRADEMARK ACKNOWLEDGEMENTS
The following are trademarks or registered trademarks of the
respective companies:
Managing Your Money, MECA - MECA Ventures Inc.
dBASE, dBASE III, dBASE III Plus - Ashton-Tate
dBASE IV - Ashton-Tate
LOTUS, 1-2-3, and Symphony - LOTUS Development Co.
IBM, IBM PC, and IBM PC-AT - IBM Corporation
HP LaserJet, Plus, and LaserJet II - Hewlett-Packard
MYM2DBd, (C) Copyright 1991 Indusoft Corp. page -4-
TERMS OF USE
MYM2DB is supplied for personal, private use. Feel free to
distribute the non-registered version of MYM2DB given these
restrictions:
- The program shall be supplied in its original, unmodified
form, which includes this documentation;
- No fee is charged other than media materials;
- "Commercial" use without a license is prohibited;
- The program may not be included, or bundled, with other
goods or services. Exceptions may be granted upon written
request only. This also applies to clubs and distributors.
WARRANTY
This program is provided AS IS without any warranty, expressed
or implied, including but not limited to the program's
suitability for any specific purpose. Considerable testing
effort has been expended in MYM2DB's development, but the user
is responsible for determining the program's suitability for
use. The user assumes full risk as to the results of using
this package. In no event shall Indusoft be liable for any
consequential damages arising from the use, or inability to use
these routines.
The idea of shareware with its low cost distribution of quality
programs can be of great value to computer users. MYM2DB
follows in that tradition.
THANK YOU FOR YOUR SUPPORT!
MYM2DBd, (C) Copyright 1991 Indusoft Corp. page -5-
-------------------- REGISTRATION BENEFITS ------------------------
Registration allows Indusoft to continue improving MYM2DB and
to develop new products for the computing community. Ideas for
future improvements include:
* Support routines and reports to help you analyze your
budgets.
* Ideas that you, our customers submit.
Mym2db registration comes in 3 versions, described below:
License to use the current and all future
shareware versions for private use ...................... $ 10
License for private and non-resale commercial use.
A disk with the latest version of MYM2DB will be
sent to you This is an extended version with
automatic creation of the DBF file (no appends to do),
no NAG screens, and any supporting Dbase code
I've developed at the time you register.
Source code is not included. ........................... $ 20
License for business and commercial use,
(includes full source code and right to
embed the object code in your product) ................ $ 30
Please make checks or money orders payable to:
Indusoft Corp.
PO Box 26747
Greenville, SC 29616-1747
MYM2DBd, (C) Copyright 1991 Indusoft Corp. page -6-
REGISTRATION - ORDER FORM
============================
Please Register MYM2DB as follows:
Shareware version ($10.00) ______
Extended version ($20.00) ______
Developer's version ($30.00) ______
Send applicable material to:
Name: ___________________________________ Phone:_____________
Company: _____________________________________________________
Address: _____________________________________________________
Address: _____________________________________________________
City, State, Zip: ____________________________________________
Where did you learn about our program?
______________________________________________________________
How can we improve MYM2DB?
______________________________________________________________
______________________________________________________________
______________________________________________________________
Please forward check or money order payable to:
Indusoft Corp.
PO Box 26747
Greenville, SC 29616-1747
MYM2DBd, (C) Copyright 1991 Indusoft Corp. page -7-
MYM2DBd, (C) Copyright 1991 Indusoft Corp. page -8-